{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5 - Simulação (NPA escolhidosde antemão)"]
[]
[null,"Chegada Exponencial de média",null,null,15]
[null,"Serviço Uniforme de min - máx",null,null,10,15]
[]
[null,"Nº Clientes",5]
[null,null,null,null,null,null,"Próx.",null,"Próx.","Próxima","Próxima","Próximo","Tempo",null,"NPA ","NPA ","Nº","Intervalo","Tempo ","Tempo","Tempo","Tempo","Tempo "]
[null,"Cliente Ch.","Cliente Nº","T. Simul.","Nº Clientes","NPA Ch","Int. CH","NPA Par","T. Serv.","Chegada","Partida","Acontec.","Espera",null,"Chegadas","Seviço","Clientes","Chegadas","Serviço","Chegada","Partida","Fila","Sistema"]
[null,1,{"$f":"SUM($B$9:B9)","v":1},0,1,5.8999999999999997E-2,{"$f":"-$E$3*LN(F9)","v":42.453267526146263},0.67300000000000004,{"$f":"$E$4+H9*($F$4-$E$4)","v":13.365},{"$f":"+D9+G9","v":42.453267526146263},{"$f":"+D9+I9","v":13.365},{"$f":"IF(J9<K9,\"chegada\",\"partida\")","v":"partida"},{"$f":"IF(E9<2,0,(E9-1)*(D10-D9))","v":0},null,5.8999999999999997E-2,0.67300000000000004,1,{"$f":"-$E$3*LN(O9)","v":42.453267526146263},{"$f":"+$E$4+P9*($F$4-$E$4)","v":13.365},0,{"$f":"+T9+S9","v":13.365},{"$f":"+U9-T9-S9","v":0},{"$f":"+U9-T9","v":13.365}]
[null,{"$f":"IF(SUM(E9:L9)=0,0,IF(L9=\"partida\",0,1))","v":0},{"$f":"SUM($B$9:B10)","v":1},{"$f":"IF(L9=\"partida\",K9,J9)","v":13.365},{"$f":"IF(L9=\"partida\",E9-1,E9+1)","v":0},{"$f":"IF(L9=\"partida\", 0,RAND())","v":0},{"$f":"IF(F10=0,0,-$E$3*LN(F10))","v":0},{"$f":"IF(L9=\"partida\",IF(E10=0,0,RAND()),IF(E10>1,0,RAND()))","v":0},{"$f":"IF(H10=0,0,$E$4+H10*($F$4-$E$4))","v":0},{"$f":"IF(C10=$C$6,0,+J9+G10)","v":42.453267526146263},{"$f":"IF(D10<K9,K9,IF(I10=0,0,D10+I10))","v":0},{"$f":"IF(C10<$C$6,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\"))),IF(E10=0,0,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\")))))","v":"chegada"},0,null,0.48,0.94899999999999995,{"$f":"+Q9+1","v":2},{"$f":"-$E$3*LN(O10)","v":11.009537626203006},{"$f":"+$E$4+P10*($F$4-$E$4)","v":14.745000000000001},{"$f":"+R9+T9","v":42.453267526146263},{"$f":"MAX(T10,U9)+S10","v":57.198267526146267},{"$f":"+U10-T10-S10","v":0},{"$f":"+U10-T10","v":14.745000000000005}]
[null,1,{"$f":"SUM($B$9:B11)","v":2},42.453267526146263,{"$f":"IF(L10=\"partida\",E10-1,E10+1)","v":1},{"$f":"IF(L10=\"partida\", 0,0.48)","v":0.48},{"$f":"IF(F11=0,0,-$E$3*LN(F11))","v":11.009537626203006},{"$f":"IF(L10=\"partida\",IF(E11=0,0,0.949),IF(E11>1,0,0.949))","v":0.94899999999999995},{"$f":"IF(H11=0,0,$E$4+H11*($F$4-$E$4))","v":14.745000000000001},53.462805152349269,{"$f":"IF(D11<K10,K10,IF(I11=0,0,D11+I11))","v":57.198267526146267},"chegada",0,null,0.61399999999999999,0.59299999999999997,{"$f":"+Q10+1","v":3},{"$f":"-$E$3*LN(O11)","v":7.3164052625249187},{"$f":"+$E$4+P11*($F$4-$E$4)","v":12.965},{"$f":"+R10+T10","v":53.462805152349269},{"$f":"MAX(T11,U10)+S11","v":70.163267526146271},{"$f":"+U11-T11-S11","v":3.7354623737970023},{"$f":"+U11-T11","v":16.700462373797002}]
[null,1,{"$f":"SUM($B$9:B12)","v":3},53.462805152349269,{"$f":"IF(L11=\"partida\",E11-1,E11+1)","v":2},{"$f":"IF(L11=\"partida\", 0,0.614)","v":0.61399999999999999},7.3164052625249187,{"$f":"IF(L11=\"partida\",IF(E12=0,0,RAND()),IF(E12>1,0,RAND()))","v":0},{"$f":"IF(H12=0,0,$E$4+H12*($F$4-$E$4))","v":0},60.779210414874186,57.198267526146267,"partida",3.7354623737969987,null,0.93400000000000005,0.17799999999999999,{"$f":"+Q11+1","v":4},{"$f":"-$E$3*LN(O12)","v":1.0241826112994157},{"$f":"+$E$4+P12*($F$4-$E$4)","v":10.89},{"$f":"+R11+T11","v":60.779210414874186},{"$f":"MAX(T12,U11)+S12","v":81.053267526146271},{"$f":"+U12-T12-S12","v":9.3840571112720852},{"$f":"+U12-T12","v":20.274057111272086}]
[null,0,{"$f":"SUM($B$9:B13)","v":3},57.198267526146267,{"$f":"IF(L12=\"partida\",E12-1,E12+1)","v":1},{"$f":"IF(L12=\"partida\", 0,RAND())","v":0},0,{"$f":"IF(L12=\"partida\",IF(E13=0,0,0.593),IF(E13>1,0,0.593))","v":0.59299999999999997},12.965,60.779210414874186,70.163267526146271,"chegada",0,null,0.23799999999999999,0.34699999999999998,{"$f":"+Q12+1","v":5},{"$f":"-$E$3*LN(O13)","v":21.532269079659937},{"$f":"+$E$4+P13*($F$4-$E$4)","v":11.734999999999999},{"$f":"+R12+T12","v":61.803393026173602},{"$f":"MAX(T13,U12)+S13","v":92.788267526146271},{"$f":"+U13-T13-S13","v":19.24987449997267},{"$f":"+U13-T13","v":30.984874499972669}]
[null,1,{"$f":"SUM($B$9:B14)","v":4},60.779210414874186,{"$f":"IF(L13=\"partida\",E13-1,E13+1)","v":2},{"$f":"IF(L13=\"partida\", 0,0.934)","v":0.93400000000000005},1.0241826112994157,{"$f":"IF(L13=\"partida\",IF(E14=0,0,RAND()),IF(E14>1,0,RAND()))","v":0},0,61.803393026173602,70.163267526146271,"chegada",1.0241826112994161]
[null,1,{"$f":"SUM($B$9:B15)","v":5},61.803393026173602,{"$f":"IF(L14=\"partida\",E14-1,E14+B15)","v":3},{"$f":"IF(C15=$C$6,0, RAND())","v":0},0,{"$f":"IF(L14=\"partida\",IF(E15=0,0,RAND()),IF(E15>1,0,RAND()))","v":0},0,0,70.163267526146271,"partida",16.719748999945338]
[null,0,{"$f":"SUM($B$9:B16)","v":5},70.163267526146271,{"$f":"IF(L15=\"partida\",E15-1,E15+B16)","v":2},0,0,{"$f":"IF(L15=\"partida\",IF(E16=0,0,0.178),IF(E16>1,0,0.178))","v":0.17799999999999999},10.89,0,81.053267526146271,{"$f":"IF(C16<$C$6,IF(C16=$C$6,\"partida\",IF(K16=0,\"chegada\",IF(J16<K16,\"chegada\",\"partida\"))),IF(E16=0,0,IF(C16=$C$6,\"partida\",IF(K16=0,\"chegada\",IF(J16<K16,\"chegada\",\"partida\")))))","v":"partida"},10.89]
[null,0,{"$f":"SUM($B$9:B17)","v":5},81.053267526146271,1,0,0,{"$f":"IF(L16=\"partida\",IF(E17=0,0,0.347),IF(E17>1,0,0.347))","v":0.34699999999999998},11.734999999999999,0,92.788267526146271,{"$f":"IF(C17<$C$6,IF(C17=$C$6,\"partida\",IF(K17=0,\"chegada\",IF(J17<K17,\"chegada\",\"partida\"))),IF(E17=0,0,IF(C17=$C$6,\"partida\",IF(K17=0,\"chegada\",IF(J17<K17,\"chegada\",\"partida\")))))","v":"partida"},0]
[null,0,{"$f":"SUM($B$9:B18)","v":5},92.788267526146271,0,0,0,{"$f":"IF(L17=0,0,IF(L17=\"partida\",IF(E18=0,0,RAND()),IF(E18>1,0,RAND())))","v":0},0,0,0,{"$f":"IF(C18<$C$6,IF(C18=$C$6,\"partida\",IF(K18=0,\"chegada\",IF(J18<K18,\"chegada\",\"partida\"))),IF(E18=0,0,IF(C18=$C$6,\"partida\",IF(K18=0,\"chegada\",IF(J18<K18,\"chegada\",\"partida\")))))","v":0},0]
[null,0,{"$f":"SUM($B$9:B19)","v":5},0,0,0,0,{"$f":"IF(L18=0,0,IF(L18=\"partida\",IF(E19=0,0,RAND()),IF(E19>1,0,RAND())))","v":0},0,0,0,{"$f":"IF(C19<$C$6,IF(C19=$C$6,\"partida\",IF(K19=0,\"chegada\",IF(J19<K19,\"chegada\",\"partida\"))),IF(E19=0,0,IF(C19=$C$6,\"partida\",IF(K19=0,\"chegada\",IF(J19<K19,\"chegada\",\"partida\")))))","v":0},0]
[null,0,{"$f":"SUM($B$9:B20)","v":5},0,0,0,0,{"$f":"IF(L19=0,0,IF(L19=\"partida\",IF(E20=0,0,RAND()),IF(E20>1,0,RAND())))","v":0},0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B21)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B22)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B23)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B24)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B25)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B26)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B27)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B28)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B29)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B30)","v":5},{"$f":"IF(L29=\"partida\",K29,J29)","v":0},{"$f":"IF(L29=\"partida\",E29-1,E29+B30)","v":0},{"$f":"IF(C30=$C$6,0, RAND())","v":0},0,{"$f":"IF(L29=0,0,IF(L29=\"partida\",IF(E30=0,0,RAND()),IF(E30>1,0,RAND())))","v":0},0,{"$f":"IF(C30=$C$6,0,+J29+G30)","v":0},{"$f":"IF(D30<K29,K29,IF(I30=0,0,D30+I30))","v":0},{"$f":"IF(C30<$C$6,IF(C30=$C$6,\"partida\",IF(K30=0,\"chegada\",IF(J30<K30,\"chegada\",\"partida\"))),IF(E30=0,0,IF(C30=$C$6,\"partida\",IF(K30=0,\"chegada\",IF(J30<K30,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E30<2,0,(E30-1)*(D31-D30))","v":0}]
[null,0,{"$f":"SUM($B$9:B31)","v":5},{"$f":"IF(L30=\"partida\",K30,J30)","v":0},{"$f":"IF(L30=\"partida\",E30-1,E30+B31)","v":0},{"$f":"IF(C31=$C$6,0, RAND())","v":0},0,{"$f":"IF(L30=0,0,IF(L30=\"partida\",IF(E31=0,0,RAND()),IF(E31>1,0,RAND())))","v":0},0,{"$f":"IF(C31=$C$6,0,+J30+G31)","v":0},{"$f":"IF(D31<K30,K30,IF(I31=0,0,D31+I31))","v":0},{"$f":"IF(C31<$C$6,IF(C31=$C$6,\"partida\",IF(K31=0,\"chegada\",IF(J31<K31,\"chegada\",\"partida\"))),IF(E31=0,0,IF(C31=$C$6,\"partida\",IF(K31=0,\"chegada\",IF(J31<K31,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E31<2,0,(E31-1)*(D32-D31))","v":0}]
[null,0,{"$f":"SUM($B$9:B32)","v":5},{"$f":"IF(L31=\"partida\",K31,J31)","v":0},{"$f":"IF(L31=\"partida\",E31-1,E31+B32)","v":0},{"$f":"IF(C32=$C$6,0, RAND())","v":0},0,{"$f":"IF(L31=0,0,IF(L31=\"partida\",IF(E32=0,0,RAND()),IF(E32>1,0,RAND())))","v":0},0,{"$f":"IF(C32=$C$6,0,+J31+G32)","v":0},{"$f":"IF(D32<K31,K31,IF(I32=0,0,D32+I32))","v":0},{"$f":"IF(C32<$C$6,IF(C32=$C$6,\"partida\",IF(K32=0,\"chegada\",IF(J32<K32,\"chegada\",\"partida\"))),IF(E32=0,0,IF(C32=$C$6,\"partida\",IF(K32=0,\"chegada\",IF(J32<K32,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E32<2,0,(E32-1)*(D33-D32))","v":0}]
[null,0,{"$f":"SUM($B$9:B33)","v":5},{"$f":"IF(L32=\"partida\",K32,J32)","v":0},{"$f":"IF(L32=\"partida\",E32-1,E32+B33)","v":0},{"$f":"IF(C33=$C$6,0, RAND())","v":0},{"$f":"-15*LN(1-F33)","v":0},{"$f":"IF(L32=0,0,IF(L32=\"partida\",IF(E33=0,0,RAND()),IF(E33>1,0,RAND())))","v":0},0,{"$f":"IF(C33=$C$6,0,+J32+G33)","v":0},{"$f":"IF(D33<K32,K32,IF(I33=0,0,D33+I33))","v":0},{"$f":"IF(C33<$C$6,IF(C33=$C$6,\"partida\",IF(K33=0,\"chegada\",IF(J33<K33,\"chegada\",\"partida\"))),IF(E33=0,0,IF(C33=$C$6,\"partida\",IF(K33=0,\"chegada\",IF(J33<K33,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E33<2,0,(E33-1)*(D34-D33))","v":0}]
[]
[]
[null,null,null,null,"Medidas de Performance",null,null,null,null,null,null,null,null,null,null,null,null,"Medidas de Performance"]
[]
[null,null,"Tempo Total de Simulação",null,null,null,{"$f":"MAX(D9:D33)","v":92.788267526146271},"minutos",null,null,null,null,null,null,null,"Tempo Total de Simulação",null,null,null,null,{"$f":"MAX(U9:U33)","v":92.788267526146271},"minutos"]
[null,null,"Tempo de Actividade (Serviço)",null,null,null,{"$f":"SUM(I9:I33)","v":63.7},"\"",null,null,null,null,null,null,null,"Tempo Total de Actividade (Serviço)",null,null,null,null,{"$f":"SUM(S9:S33)","v":63.7},"\""]
[null,null,"Tempo Total na Fila",null,null,null,{"$f":"SUM(M9:M33)","v":32.369393985041754},"\"",null,null,null,null,null,null,null,"Tempo Total na Fila",null,null,null,null,{"$f":"SUM(V9:V9:V33)","v":32.369393985041754},"\""]
[null,null,"Tempo no Sistema",null,null,null,{"$f":"+G40+G39","v":96.069393985041756},"\"",null,null,null,null,null,null,null,"Tempo Total no Sistema",null,null,null,null,{"$f":"SUM(W9:W10:W33)","v":96.069393985041756},"\""]
[null,null,"Tempo de Inactividade",null,null,null,{"$f":"G38-G39","v":29.088267526146268},"\"",null,null,null,null,null,null,null,"Tempo Total de Inactividade",null,null,null,null,{"$f":"+U38-U39","v":29.088267526146268},"\""]
[]
[null,null,"Comprimento médio da Fila",null,null,null,{"$f":"+G40/MAX(D9:D33)","v":0.34885222936100807},"clientes",null,null,null,null,null,null,null,"Compriento médio fila",null,null,null,null,{"$f":"+U40/U38","v":0.34885222936100807},"clientes"]
[null,null,"Nº médio clientes no Sistema",null,null,null,{"$f":"+G41/MAX(D9:D33)","v":1.0353614368106498},"\"",null,null,null,null,null,null,null,"Nº médio Clientes no Sistema",null,null,null,null,{"$f":"+U41/U38","v":1.0353614368106498},"\""]
[null,null,"Tempo médio na Fila",null,null,null,{"$f":"+G40/MAX(C9:C33)","v":6.4738787970083509},"\"",null,null,null,null,null,null,null,"Tempo médio na fila",null,null,null,null,{"$f":"+U40/MAX(Q9:Q33)","v":6.4738787970083509},"minutos"]
[null,null,"Tempo médio no Sistema",null,null,null,{"$f":"+G41/MAX(C9:C33)","v":19.213878797008352},"\"",null,null,null,null,null,null,null,"Tempo médio no Sistema",null,null,null,null,{"$f":"+U41/MAX(Q9:Q33)","v":19.213878797008352},"\""]
[]
[null,null,"% Utilização média do Serviço",null,null,null,{"$f":"+G39/G38*100","v":68.650920744964168}," %",null,null,null,null,null,null,null,"%Utilização do Sistema",null,null,null,null,{"$f":"+U39/U38*100","v":68.650920744964168},"%"]
[null,null,"% Inactividade do Sistema",null,null,null,{"$f":"+G42/G38*100","v":31.349079255035829},"%",null,null,null,null,null,null,null,"% Inactividade do Sistema",null,null,null,null,{"$f":"+U42/U38*100","v":31.349079255035829},"%"]

{"sheet":"Sheet2","index":1,"n_rows":105,"n_cols":31,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5.4 - Simulação"]
[]
[null,null,null,null,null,null,null,null,null,null,"Unidade: minuto",null,null,null,null,null,null,null,null,null,"Medidas  de Performance : 100 Runs"]
[null,null,null,"média","min",null,"max","NPA","NPA","Nº Clientes","Intervalo","Tempo","Tempo","Tempo","Tempo ","Tempo",null,null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13"]
[null,null,null,null,null,null,null,"Cheg","Serv",null,"Chegadas","Serviço","Chegada","Partida","Fila","Sistema",null,null,{"$f":"+G10","v":1257.6993996771014},{"$f":"+G11","v":2362.1732374313283},{"$f":"+G12","v":3619.8726371084299},{"$f":"+G13","v":273.8088477107658},{"$f":"+G14","v":1531.5082473878672},{"$f":"+G15","v":100},{"$f":"+G17","v":1.5423836218056541},{"$f":"+G18","v":2.363599832571889},{"$f":"+G19","v":23.621732374313282},{"$f":"+G20","v":36.198726371084298},{"$f":"+G21","v":12.576993996771014},{"$f":"+G23","v":17.878378923376534},{"$f":"+G24","v":82.12162107662347}]
[null,"Exponencial",null,15,null,null,null,{"$f":"RAND()","v":0.46843440919820745},{"$f":"RAND()","v":0.27736009322912569},1,{"$f":"-$D$6*LN(1-H6)","v":9.4789302277401735},{"$f":"+$E$7+I6*($G$7-$E$7)","v":11.386800466145628},0,{"$f":"+M6+L6","v":11.386800466145628},{"$f":"+N6-M6-L6","v":0},{"$f":"+N6-M6","v":11.386800466145628},null,1,1252.1769968490908,2348.849627218784,3601.0266240678748,181.81244080783063,1433.9894376569214,100,1.637982516145102,2.5111946639940399,23.488496272187842,36.010266240678746,12.521769968490908,12.678785215106222,87.321214784893769]
[null,"Uniforme",null,null,10,null,15,{"$f":"RAND()","v":0.47367792890924543},0.36109562259987016,{"$f":"+J6+1","v":2},9.6276292675677517,{"$f":"+$E$7+I7*($G$7-$E$7)","v":11.805478112999351},{"$f":"+M6+K6","v":9.4789302277401735},{"$f":"MAX(M7,N6)+L7","v":23.192278579144979},{"$f":"+N7-M7-L7","v":1.9078702384054544},{"$f":"+N7-M7","v":13.713348351404806},null,{"$f":"+R6+1","v":2},1263.2638845626097,1209.1571254549283,2472.4210100175378,284.19397504659696,1547.4578596092067,100,0.78138291000718263,1.5977307521911583,12.091571254549283,24.724210100175377,12.632638845626097,18.365215781602416,81.634784218397584]
[null,null,null,null,null,null,null,0.65255932963267493,0.84275008804456064,{"$f":"+J7+1","v":3},15.857420419645283,14.213750440222803,{"$f":"+M7+K7","v":19.106559495307927},{"$f":"MAX(M8,N7)+L8","v":37.406029019367779},4.0857190838370485,18.299469524059852,null,{"$f":"+R7+1","v":3},1232.3775454990359,1786.7235931294151,3019.1011386284499,526.68744187167067,1759.0649873707066,100,1.0157234701146829,1.7163101763176658,17.86723593129415,30.191011386284501,12.32377545499036,29.94132937970166,70.058670620298329]
[null,null,null,null,"Média",null," Run 0",0.8197283911492621,0.38645269995895881,4,25.699359410030542,11.932263499794795,34.963979914953214,49.338292519162572,2.4420491044145631,14.374312604209358,null,4,1270.9001545700298,1598.2428974074339,2869.1430519774626,339.73891654912313,1610.639071119153,100,0.99230356823325694,1.7813693355792231,15.98242897407434,28.691430519774627,12.709001545700298,21.093423265403306,78.906576734596683]
[null,"Tempo Total de Actividade (Serviço)",null,"M1",{"$f":"AVERAGE(S5:S105)","v":1248.5481514720527},null,{"$f":"SUM(L6:L5055)","v":1257.6993996771014},0.78479765556941494,0.60410292074064476,5,23.042648348395208,13.020514603703223,60.663339324983752,73.683853928686972,0,13.020514603703219,null,5,1265.7207626471622,3183.7123403033206,4449.4331029504838,209.2424665297483,1474.9632291769105,100,2.1585028543931646,3.0166400184996127,31.837123403033207,44.494331029504835,12.657207626471623,14.186283589355247,85.813716410644744]
[null,"Tempo Total na Fila",null,"M2",{"$f":"AVERAGE(T5:T105)","v":2661.3069924455945},null,{"$f":"SUM(O6:O5055)","v":2362.1732374313283},0.54107945318663431,3.2841965017962105E-2,6,11.683172767945647,10.164209825089811,83.705987673378957,93.870197498468769,0,10.164209825089813,null,6,1229.9243088572257,3653.4770267896606,4883.4013356468849,177.5750470564119,1407.4993559136376,100,2.595721988389907,3.4695584869216272,36.534770267896604,48.834013356468851,12.299243088572258,12.616350146827896,87.383649853172102]
[null,"Tempo Total no Sistema",null,"M3",{"$f":"AVERAGE(U5:U105)","v":3909.8551439176463},null,{"$f":"SUM(P6:P5055)","v":3619.8726371084299},0.86752821364070165,0.57507054786135903,7,30.320783840500653,12.875352739306795,95.389160441324606,108.2645131806314,0,12.875352739306791,null,7,1259.4195184184298,3392.6844724701091,4652.1039908885368,193.2819755283258,1452.7014939467556,100,2.3354312545330513,3.2023812257874953,33.926844724701091,46.521039908885371,12.594195184184297,13.305002874555448,86.694997125444544]
[null,"Tempo Total de Inactividade",null,"M4",{"$f":"AVERAGE(V5:V105)","v":261.29684149190706},null,{"$f":"+G14-G10","v":273.8088477107658},0.61602706142285346,0.99671049330330852,8,14.357748019995869,14.983552466516542,125.70994428182526,140.6934967483418,0,14.983552466516542,null,8,1248.4975534703292,2856.0715869675896,4104.5691404379195,365.76672344776239,1614.2642769180916,100,1.7692713812761327,2.542687216168996,28.560715869675896,41.045691404379198,12.484975534703292,22.658416510713725,77.341583489286265]
[null,"Tempo Total de Simulação",null,"M5",{"$f":"AVERAGE(W5:W105)","v":1509.8449929639601},null,{"$f":"+MAX(N6:N5055)","v":1531.5082473878672},0.89585598777212216,0.14169209331241117,9,33.929709071084041,10.708460466562055,140.06769230182113,151.40195721490386,0.62580444652067868,11.334264913082734,null,9,1255.6078264422497,5884.8193753430069,7140.4272017852563,241.01781359833603,1496.6256400405857,100,3.9320583704442091,4.7710175549255061,58.848193753430067,71.404272017852563,12.556078264422498,16.104081551870252,83.895918448129748]
[null,"Nº Clientes",null,"M6",{"$f":"AVERAGE(X5:X105)","v":100},null,{"$f":"MAX(J6:J105)","v":100},0.60164613095061614,4.8267855242567603E-2,10,13.806218257719465,10.241339276212837,173.99740137290516,184.238740649118,0,10.241339276212841,null,10,1251.6097241958,1546.4505009318079,2798.0602251276077,446.2838271423002,1697.8935513381002,100,0.91080533270949704,1.6479597457228532,15.46450500931808,27.980602251276078,12.516097241958001,26.28455869866438,73.715441301335616]
[null,null,null,null,null,null,null,0.99171860570904613,0.1146978505404036,11,71.906158982012059,10.573489252702018,187.80361963062461,198.37710888332663,0,10.573489252702018,null,11,1237.5136277644103,2412.2809457428061,3649.794573507219,194.53540237357151,1432.0490301379818,100,1.6844960577295152,2.5486519642107166,24.122809457428062,36.497945735072193,12.375136277644103,13.584409351880048,86.415590648119959]
[null,"Comprimento médio fila",null,"M7",{"$f":"AVERAGE(Y5:Y105)","v":1.8302668653203569},null,{"$f":"+G11/G14","v":1.5423836218056541},0.77871805787531556,0.78373443743996696,12,22.624764514944005,13.918672187199835,259.70977861263668,273.62845079983651,0,13.918672187199832,null,12,1233.9598280778166,1805.2714106847509,3039.231238762568,293.0429191337862,1527.0027472116028,100,1.1822319337547251,1.9903246698883703,18.05271410684751,30.39231238762568,12.339598280778166,19.190726386635511,80.809273613364482]
[null,"Nº médio Cl. Sistema",null,"M8",{"$f":"AVERAGE(Z5:Z105)","v":2.6628625876020986},null,{"$f":"+G12/G14","v":2.363599832571889},0.6538302694936291,0.52178491468975696,13,15.912391104128623,12.608924573448785,282.33454312758067,294.94346770102948,1.7763568394002505E-14,12.608924573448803,null,13,1243.2764916068395,2028.8537576617282,3272.1302492685668,347.24699320085415,1590.5234848076936,100,1.2755886832485419,2.0572662274547882,20.288537576617284,32.721302492685666,12.432764916068395,21.832245579375332,78.167754420624675]
[null,"Tempo médio na fila",null,"M9",{"$f":"AVERAGE(AA5:AA105)","v":26.613069924455957},null,{"$f":"+G11/G15","v":23.621732374313282},0.49811203221162759,0.28021833564677767,14,10.34067533899853,11.401091678233888,298.2469342317093,309.64802590994321,2.3092638912203256E-14,11.401091678233911,null,14,1243.7100372958951,1792.4746728846403,3036.1847101805361,256.57101004156948,1500.2810473374645,100,1.1947592593172653,2.0237439615522881,17.924746728846404,30.36184710180536,12.43710037295895,17.101529776497795,82.898470223502201]
[null,"Tempo médio no Sistema",null,"M10",{"$f":"AVERAGE(AB5:AB105)","v":39.098551439176475},null,{"$f":"+G12/G15","v":36.198726371084298},0.35383381150729454,0.2764946876935841,15,6.5504782583397647,11.382473438467921,308.58760957070785,321.03049934841113,1.0604163392353509,12.442889777703272,null,15,1259.1831220332022,1702.2809744651966,2961.4640964983996,233.73997787248686,1492.923099905689,100,1.1402335288219019,1.9836682121707951,17.022809744651966,29.614640964983995,12.591831220332022,15.656531665110727,84.343468334889266]
[null,"Tempo médio no Serviço",null,"M11",{"$f":"AVERAGE(AC5:AC105)","v":12.485481514720522},null,{"$f":"+G10/G15","v":12.576993996771014},0.98745271418184555,0.5496725163774242,16,65.67376359395584,12.748362581887122,315.13808782904761,333.77886193029826,5.8924115193635345,18.640774101250656,null,16,1266.0072196528654,3448.4481192394483,4714.4553388923141,180.43947271392244,1446.4466923667878,100,2.3840824120499255,3.259335697451911,34.484481192394483,47.144553388923143,12.660072196528654,12.474671459801497,87.525328540198501]
[null,null,null,null,null,null,null,0.14563650444772536,0.62798418704844694,17,2.3609780539812015,13.139920935242234,380.81185142300342,393.95177235824565,0,13.13992093524223,null,17,1287.7399800241783,1465.6190492657181,2753.3590292898962,340.50489561102881,1628.2448756352071,100,0.90012200940841547,1.6909981234952527,14.656190492657181,27.53359029289896,12.877399800241783,20.912388591316269,79.087611408683728]
[null,"% Inactividade do Sistema",null,"M12",{"$f":"AVERAGE(AD5:AD105)","v":16.740427771825907},null,{"$f":"+G13/G14*100","v":17.878378923376534},0.78111223155001352,0.79973899000459825,18,22.787942300337452,13.99869495002299,383.17282947698465,407.95046730826863,10.778942881260992,24.777637831283982,null,18,1269.1544461088963,2059.6487792526173,3328.803225361512,240.19220267741048,1509.3466487863068,100,1.3645962515693917,2.2054597120139787,20.596487792526172,33.288032253615121,12.691544461088963,15.913653955541188,84.086346044458821]
[null,"%Utilização do Sistema",null,"M13",{"$f":"AVERAGE(AE5:AE105)","v":83.259572228174108},null,{"$f":"+G10/G14*100","v":82.12162107662347},0.60584126353470469,0.86254545518672043,19,13.965023495859899,14.312727275933602,405.96077177732212,422.26319458420221,1.9896955309464861,16.302422806880088,null,19,1237.8018266099148,1247.350084355849,2485.1519109657656,342.78402811971364,1580.5858547296284,100,0.78916945930103755,1.5722979574500053,12.47350084355849,24.851519109657655,12.378018266099147,21.687150185103331,78.312849814896666]
[null,null,null,null,null,null,null,0.24581931237144372,0.71063744855635713,20,4.231849513774498,13.553187242781785,419.92579527318202,435.81638182698401,2.33739931102021,15.890586553801995,null,20,1257.8166532501798,3558.0204659878104,4815.8371192379918,292.61328058426216,1550.429933834442,100,2.2948605340638006,3.1061301218093202,35.580204659878106,48.158371192379917,12.578166532501799,18.873041225448116,81.126958774551881]
[null,null,null,null,null,null,null,0.82142474850078684,0.66427705829639949,21,25.841177843619995,13.321385291481997,424.1576447869565,449.137767118466,11.658737040027509,24.980122331509506,null,21,1259.7419970942092,1330.6001880502536,2590.3421851444627,318.47562548548467,1578.2176225796939,100,0.84310311139176464,1.6413086180791652,13.306001880502535,25.903421851444627,12.597419970942092,20.179449331259946,79.820550668740054]
[null,null,null,null,null,null,null,0.42457465490187463,0.30435562345814438,22,8.2896867156777478,11.521778117290722,449.99882263057651,461.52060074786721,-2.8421709430404007E-14,11.521778117290694,null,22,1247.1093920686085,2337.7188949699248,3584.8282870385365,371.92390200649129,1619.0332940750998,100,1.4438979751218683,2.2141782384323543,23.377188949699249,35.848282870385361,12.471093920686085,22.971973668951577,77.028026331048423]
[null,"Nº de Runs = 101",null,null,null,null,null,0.39275660415610603,0.31517580970939196,23,7.48238380010058,11.575879048546959,458.28850934625427,473.09647979641414,3.2320914016129123,14.807970450159871,null,23,1222.4805388563598,1060.8506297369634,2283.3311685933222,310.37172284289204,1532.8522616992518,100,0.69207623998998546,1.4895963724919732,10.608506297369633,22.833311685933221,12.224805388563597,20.247986749801168,79.752013250198829]
[null,null,null,null,null,null,null,0.15552066097815365,0.13011215328624715,24,2.5355251255772306,10.650560766431235,465.77089314635487,483.74704056284537,7.3255866500592699,17.976147416490505,null,24,1235.1726719040985,1014.2626404901324,2249.435312394231,579.14814545210629,1814.3208173562048,100,0.559031584043718,1.2398222469122451,10.142626404901325,22.494353123942311,12.351726719040984,31.920933713147292,68.079066286852708]
[null,null,null,null,null,null,null,0.51701903968425145,0.74965716634178137,25,10.91667068614005,13.748285831708907,468.3064182719321,497.4953263945543,15.440622290913288,29.188908122622195,null,25,1258.5028711570098,2040.4339570677821,3298.936828224792,259.61226662146191,1518.1151377784718,100,1.3440574474829647,2.1730478447453461,20.40433957067782,32.989368282247916,12.585028711570098,17.100960273761881,82.899039726238115]
[null,null,null,null,null,null,null,0.62585157375960621,0.81956730148605084,26,14.746540480365182,14.097836507430255,479.22308895807214,511.59316290198456,18.272237436482161,32.370073943912416,null,26,1256.8761174554058,876.66265456866984,2133.5387720240751,280.05121312120082,1536.9273305766067,100,0.57039954793423686,1.3881845482073889,8.7666265456866981,21.33538772024075,12.568761174554059,18.22149997268475,81.778500027315246]
[null,null,null,null,null,null,null,0.94922240425894533,0.89579455858281232,27,44.704500755982998,14.47897279291406,493.96962943843732,526.07213569489863,17.62353346354725,32.102506256461311,null,27,1236.0421541229211,3072.2308853310383,4308.2730394539585,169.18611748526723,1405.2282716081884,100,2.186285991680966,3.0658883873176226,30.722308853310384,43.082730394539588,12.360421541229211,12.039760436334319,87.960239563665681]
[null,null,null,null,null,null,null,0.67003156728507496,0.88614424054542162,28,16.631374313051886,14.430721202727108,538.67413019442029,553.1048513971474,0,14.430721202727113,null,28,1250.2461552405878,6425.3536433184363,7675.5997985590229,62.9409212421549,1313.1870764827427,100,4.8929461448312352,5.8450162478886476,64.253536433184365,76.755997985590227,12.502461552405878,4.7929896942586945,95.207010305741306]
[null,null,null,null,null,null,null,0.84993517851152756,0.50090026008124089,29,28.450319024646053,12.504501300406204,555.30550450747216,567.81000580787838,1.4210854715202004E-14,12.504501300406218,null,29,1234.6490510156623,2177.0101486902786,3411.6591997059409,106.6716958306215,1341.3207468462838,100,1.6230347244004608,2.5435073659506431,21.770101486902785,34.116591997059409,12.346490510156622,7.9527358449817633,92.04726415501824]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.55426560595179952},{"$f":"RAND()","v":0.43693777157072899},30,12.120480500997521,12.184688857853645,583.75582353211826,595.9405123899719,0,12.184688857853644,null,30,1274.8797571104822,1857.0790713731287,3131.9588284836127,254.44379284054821,1529.3235499510304,100,1.2143140484775725,2.0479373567378203,18.570790713731288,31.319588284836126,12.748797571104822,16.637669173975357,83.362330826024646]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.2423484905534512},0.74333743503177607,{"$f":"+J35+1","v":31},4.162976236916232,{"$f":"+$E$7+I36*($G$7-$E$7)","v":13.716687175158881},{"$f":"+M35+K35","v":595.87630403311573},{"$f":"MAX(M36,N35)+L36","v":609.65719956513078},{"$f":"+N36-M36-L36","v":6.4208356856170212E-2},{"$f":"+N36-M36","v":13.780895532015052},null,31,1232.9235167185429,1878.060489317857,3110.9840060363995,184.9269804331359,1417.8504971516788,100,1.3245828760441911,2.1941551752360762,18.78060489317857,31.109840060363993,12.329235167185429,13.042770080811472,86.957229919188535]
[null,null,null,null,null,null,null,0.77288579803316004,5.8806800528146463E-2,32,22.23453443466504,10.294034002640732,600.03928027003201,619.95123356777151,9.6179192950987691,19.911953297739501,null,32,1258.3613568610929,4508.7192620431188,5767.0806189042114,74.284120363724696,1332.6454772248176,100,3.3832848563988311,4.3275430093485427,45.087192620431189,57.670806189042111,12.583613568610929,5.5741847050288635,94.425815294971144]
[null,null,null,null,null,null,null,0.33090422877488812,0.52165466926858683,33,{"$f":"-$D$6*LN(1-H38)","v":6.027421099609902},12.608273346342934,622.27381470469709,634.88208805104,-2.1316282072803006E-14,12.608273346342912,null,33,1248.6520248422016,2694.7909760596935,3943.4430009018943,105.96947464919299,1354.6214994913946,100,1.9893313202776408,2.9111032139844948,26.947909760596936,39.434430009018939,12.486520248422016,7.822810629314553,92.177189370685454]
[null,null,null,null,null,null,null,0.46351718339752634,2.4524919104588649E-2,34,9.3408111918640433,10.122624595522943,628.301235804307,645.00471264656289,6.5808522467329524,16.703476842255895,null,34,1240.4997113084794,1107.1130607178595,2347.6127720263394,450.64621413987084,1691.1459254483502,100,0.65465259032826861,1.3881787116649613,11.071130607178596,23.476127720263392,12.404997113084795,26.647387866330767,73.35261213366924]
[null,null,null,null,null,null,null,0.75281496003479065,0.88827955999384112,35,20.964271097549663,14.441397799969206,637.64204699617108,659.44611044653209,7.3626656503918078,21.804063450361014,null,35,1267.2717895770693,2824.7544366140596,4092.0262261911289,408.6425607924707,1675.91435036954,100,1.685500476794175,2.4416678723998246,28.247544366140595,40.92026226191129,12.672717895770694,24.383260439435034,75.616739560564966]
[null,null,null,null,null,null,null,0.31353145722615272,0.67011440745566098,36,5.6429231616058644,13.350572037278305,658.60631809372069,672.7966824838104,0.83979235281140774,14.190364390089712,null,36,1240.1729834122416,1880.8948865802311,3121.0678699924738,286.00548028815592,1526.1784637003975,100,1.2324213264153803,2.0450215647946446,18.808948865802311,31.210678699924738,12.401729834122415,18.739976162073621,81.260023837926383]
[null,null,null,null,null,null,null,0.43371555025831232,0.43703296677583869,37,8.5298814845933553,12.185164833879194,664.24924125532652,684.98184731768958,8.5474412284838674,20.732606062363061,null,37,1265.8878434544836,3575.2820173163482,4841.1698607708313,138.2880309417726,1404.1758743962562,100,2.546178212080155,3.44769480023459,35.752820173163485,48.41169860770831,12.658878434544835,9.8483411845564834,90.151658815443511]
[null,null,null,null,null,null,null,0.72658388925483364,7.3944924638584264E-2,38,19.451406435755406,10.369724623192921,672.7791227399199,695.35157194088254,12.202724577769716,22.572449200962637,null,38,1241.8644015319471,2604.1808953833374,3846.0452969152866,362.86098439816669,1604.7253859301138,100,1.6228202770494153,2.3966999778507789,26.041808953833375,38.460452969152868,12.418644015319471,22.612029919863772,77.387970080136228]
[null,null,null,null,null,null,null,0.20818099362940101,0.5188823703719212,39,3.5013366089085838,12.594411851859606,692.23052917567531,707.94598379274214,3.1210427652072195,15.715454617066825,null,39,1231.4773595867641,2509.6359094785103,3741.1132690652767,241.73143993953363,1473.2087995262978,100,1.7035167793495871,2.5394317969511255,25.096359094785104,37.411132690652764,12.314773595867642,16.408498239846317,83.59150176015369]
[null,null,null,null,null,null,null,0.9088243148567301,0.93923390463438639,40,35.924505415797768,14.696169523171932,695.73186578458387,722.64215331591413,12.214118008158323,26.910287531330255,null,40,1242.9464903939706,1617.9899702796372,2860.9364606736081,294.63607928811348,1537.5825696820841,100,1.0522946878971049,1.860671756486642,16.179899702796373,28.609364606736079,12.429464903939706,19.162293141046302,80.837706858953695]
[null,null,null,null,null,null,null,0.18759172946959923,0.97926486311789152,41,3.1162840344062896,14.896324315589457,731.65637120038161,746.5526955159711,2.4868995751603507E-14,14.896324315589482,null,41,1239.6370580484349,6858.2749200246699,8097.9119780731071,77.423567574996468,1317.0606256234314,100,5.2072583346558563,6.1484732141619949,68.582749200246695,80.979119780731068,12.39637058048435,5.8785120493863356,94.12148795061367]
[null,null,null,null,null,null,null,0.85462582375400609,0.62681983981816047,42,28.926665018504568,13.134099199090802,734.77265523478786,759.68679471506186,11.780040281183201,24.914139480274002,null,42,1232.4904412904127,1088.0526795625351,2320.5431208529481,541.59041003922698,1774.0808513296397,100,0.61330501298577256,1.3080255722921226,10.88052679562535,23.205431208529479,12.324904412904127,30.527944069365009,69.472055930634994]
[null,null,null,null,null,null,null,7.4660301449964939E-2,0.85147279804266229,43,1.1639155081607622,14.25736399021331,763.6993202532924,777.95668424350572,0,14.257363990213321,null,43,1231.5865006756012,3762.7264422116173,4994.3129428872162,93.587672131764066,1325.1741728073653,100,2.8394202961564874,3.7687973742401164,37.62726442211617,49.943129428872162,12.315865006756011,7.0622921916369474,92.937707808363058]
[null,null,null,null,null,null,null,0.69658901233239467,0.71033016462098697,44,17.890004964042095,13.551650823104936,764.86323576145321,791.5083350666107,13.093448482052551,26.645099305157487,null,44,1254.1024395829957,4561.9027574409274,5816.0051970239228,102.34995643929983,1356.4523960222955,100,3.3631130519717445,4.2876589064820578,45.619027574409273,58.16005197023923,12.541024395829957,7.545414548968628,92.454585451031363]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.78861025535100293},{"$f":"RAND()","v":0.42641849402377308},45,23.3107757747531,12.132092470118865,782.75324072549529,803.64042753672959,8.7550943411154361,20.887186811234301,null,45,1244.1442965331489,1695.0751268587965,2939.2194233919463,297.41171335632885,1541.5560098894778,100,1.0995871158650443,1.9066575619284014,16.950751268587965,29.392194233919462,12.44144296533149,19.292955393664343,80.707044606335657]
[null,null,null,null,null,null,null,1.8469933446511044E-3,0.80450856315328589,{"$f":"+J50+1","v":46},2.7730517100607383E-2,{"$f":"+$E$7+I51*($G$7-$E$7)","v":14.022542815766428},{"$f":"+M50+K50","v":806.06401650024839},{"$f":"MAX(M51,N50)+L51","v":820.08655931601481},{"$f":"+N51-M51-L51","v":0},{"$f":"+N51-M51","v":14.022542815766428},null,46,1254.6101023282179,8323.2077874472234,9577.8178897754406,107.54645340461911,1362.156555732837,100,6.1103165802915784,7.0313635018425602,83.232077874472239,95.778178897754401,12.546101023282178,7.8953078449018204,92.104692155098178]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.82931286764064782},0.9867138121440695,{"$f":"+J51+1","v":47},26.518845504480428,{"$f":"+$E$7+I52*($G$7-$E$7)","v":14.933569060720348},{"$f":"+M51+K51","v":806.09174701734901},{"$f":"MAX(M52,N51)+L52","v":835.02012837673522},{"$f":"+N52-M52-L52","v":13.99481229866586},{"$f":"+N52-M52","v":28.928381359386208},null,47,1256.592499417432,1758.9207931864657,3015.5132926038978,411.31728879465231,1667.9097882120843,100,1.0545659037542676,1.8079594675419328,17.589207931864657,30.155132926038977,12.565924994174321,24.660643621233486,75.33935637876651]
[null,null,null,null,null,null,null,0.16166610106420043,0.84097292786404187,{"$f":"+J52+1","v":48},2.6450821566258709,{"$f":"+$E$7+I53*($G$7-$E$7)","v":14.20486463932021},{"$f":"+M52+K52","v":832.6105925218294},{"$f":"MAX(M53,N52)+L53","v":849.22499301605546},{"$f":"+N53-M53-L53","v":2.409535854905851},{"$f":"+N53-M53","v":16.614400494226061},null,48,1218.6670487073625,1100.6981267574934,2319.3651754648549,473.74953668648595,1692.4165853938484,100,0.65037068075136228,1.370445784732786,11.006981267574934,23.193651754648549,12.186670487073625,27.992489601857567,72.007510398142429]
[null,null,null,null,null,null,null,0.54193779436845047,0.66757349023121793,{"$f":"+J53+1","v":49},11.711254259016792,{"$f":"+$E$7+I54*($G$7-$E$7)","v":13.33786745115609},{"$f":"+M53+K53","v":835.25567467845531},{"$f":"MAX(M54,N53)+L54","v":862.56286046721152},{"$f":"+N54-M54-L54","v":13.969318337600125},{"$f":"+N54-M54","v":27.307185788756215},null,49,1258.9343505555464,2410.3169610011619,3669.2513115567072,184.81952955360657,1443.753880109153,100,1.6694791225904329,2.5414659396650756,24.103169610011619,36.692513115567074,12.589343505555464,12.801318292535674,87.198681707464317]
[null,null,null,null,null,null,null,0.8708072071579197,5.7221995153115546E-2,{"$f":"+J54+1","v":50},30.69674208218396,{"$f":"+$E$7+I55*($G$7-$E$7)","v":10.286109975765578},{"$f":"+M54+K54","v":846.96692893747206},{"$f":"MAX(M55,N54)+L55","v":872.84897044297713},{"$f":"+N55-M55-L55","v":15.595931529739493},{"$f":"+N55-M55","v":25.882041505505072},null,50,1234.6506550909835,3545.727995928532,4780.3786510195177,100.12484764838655,1334.77550273937,100,2.6564227382444519,3.581410238057793,35.457279959285323,47.803786510195181,12.346506550909835,7.5012500186660267,92.498749981333972]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.16941448665079195},0.17915452781334729,{"$f":"+J55+1","v":51},2.7843658368844548,{"$f":"+$E$7+I56*($G$7-$E$7)","v":10.895772639066736},{"$f":"+M55+K55","v":877.66367101965602},{"$f":"MAX(M56,N55)+L56","v":888.55944365872278},{"$f":"+N56-M56-L56","v":2.6645352591003757E-14},{"$f":"+N56-M56","v":10.895772639066763},null,51,1222.7645750011418,2636.274929939525,3859.0395049406693,177.61045277820881,1400.3750277793506,100,1.8825492297731179,2.7557185956537329,26.362749299395251,38.590395049406695,12.227645750011417,12.683063411938669,87.316936588061338]
[null,null,null,null,null,null,null,0.68695446004652505,0.31343517331387571,52,17.42109905949507,11.567175866569379,880.44803685654051,900.1266195252922,8.1114068021823087,19.678582668751687,null,52,1233.2957321699025,3844.7601332741283,5078.0558654440329,118.76999512768589,1352.0657272975884,100,2.8436192528589257,3.755775893819663,38.447601332741286,50.780558654440327,12.332957321699025,8.7843359039264151,91.215664096073581]
[null,null,null,null,null,null,null,0.11816269564375637,0.60664510618508338,53,1.8862155325757404,13.033225530925417,897.86913591603559,913.15984505621759,2.2574836092565853,15.290709140182003,null,53,1231.6001678909827,1621.9618192578134,2853.5619871487961,386.20678290717797,1617.8069507981606,100,1.0025682102908526,1.7638457949145068,16.219618192578135,28.53561987148796,12.316001678909826,23.872241537634579,76.127758462365421]
[null,null,null,null,null,null,null,0.98022484110122254,0.75676945807622342,54,58.849930950364431,13.783847290381118,899.75535144861135,926.94369234659871,13.404493607606241,27.188340897987359,null,54,1251.905344495721,7058.0077822943349,8309.9131267900539,49.597132791912827,1301.5024772876338,100,5.4229691494736247,6.3848615517875436,70.580077822943352,83.099131267900532,12.51905344495721,3.8107597686079386,96.189240231392063]
[null,null,null,null,null,null,null,0.58817488921090866,0.70771794289379242,55,13.307347621939464,13.538589714468962,958.60528239897576,972.14387211344467,-4.9737991503207013E-14,13.538589714468912,null,55,1275.0751826604705,3356.9010566014763,4631.9762392619468,172.27724814680209,1447.3524308072726,100,2.3193390808962384,3.2003098489829629,33.569010566014761,46.319762392619467,12.750751826604706,11.902923191327565,88.097076808672441]
[null,null,null,null,null,null,null,0.1342002348627287,0.25236179654535884,56,2.1615242286152485,11.261808982726794,971.91263002091523,983.40568109617152,0.23124209252949512,11.49305107525629,null,56,1249.8478461500849,3605.3285948292437,4855.1764409793259,139.15520523573491,1389.0030513858198,100,2.5956232358396747,3.4954397228539391,36.053285948292434,48.551764409793257,12.498478461500849,10.018351298573362,89.981648701426636]
[null,null,null,null,null,null,null,0.10667463512760089,0.21747541368161816,57,1.6920662115612497,11.087377068408092,974.07415424953047,994.49305816457957,9.3315268466410082,20.4189039150491,null,57,1253.0703121247811,1479.325462646013,2732.3957747707932,405.99893193643652,1659.0692440612177,100,0.89165986768869765,1.6469449871074646,14.793254626460129,27.323957747707933,12.530703121247811,24.471488058123249,75.528511941876758]
[null,null,null,null,null,null,null,0.5884047432006555,0.393537536740862,58,13.315721983496378,11.967687683704311,975.76622046109173,1006.4607458482839,18.726837703487817,30.69452538719213,null,58,1251.7766873856365,1689.0903553909452,2940.8670427765819,239.86176801706051,1491.638455402697,100,1.132372492324182,1.9715682658386795,16.890903553909453,29.40867042776582,12.517766873856365,16.080422648550257,83.919577351449746]
[null,null,null,null,null,null,null,0.86508154939688797,0.84191067803170105,59,30.046271290107573,14.209553390158504,989.08194244458809,1020.6702992384423,17.378803403695741,31.588356793854246,null,59,1247.3981185049636,7345.9069240253857,8593.30504253035,63.960741190541512,1311.3588596955051,100,5.601751854355939,6.5529774546425061,73.459069240253854,85.933050425303506,12.473981185049636,4.8774399713433949,95.122560028656594]
[null,null,null,null,null,null,null,0.16001002568293043,0.88690900305497489,60,2.6154798382923956,14.434545015274875,1019.1282137346957,1035.1048442537171,1.5420855037465806,15.976630519021455,null,60,1245.59595393771,2057.4710519271234,3303.0670058648338,220.77421726366561,1466.3701712013756,100,1.4031048178247294,2.2525465061517718,20.574710519271235,33.03067005864834,12.455959539377099,15.055831167295807,84.944168832704193]
[null,null,null,null,null,null,null,0.81026285298260414,9.3515288495111148E-2,61,24.931734021064834,10.467576442475556,1021.743693572988,1045.5724206961927,13.361150680729102,23.828727123204658,null,61,1251.1254667544667,2447.6020479988656,3698.7275147533319,311.68470958668445,1562.8101763411512,100,1.5661544089309605,2.3667157859265973,24.476020479988655,36.987275147533317,12.511254667544668,19.943862300436273,80.056137699563735]
[null,null,null,null,null,null,null,0.29505850566569625,0.28477053900727711,62,5.2446069955996935,11.423852695036386,1046.675427594053,1058.0992802890894,4.4408920985006262E-14,11.42385269503643,null,62,1247.2833111664675,1966.9226693403971,3214.2059805068648,211.47732058362863,1458.7606317500961,100,1.3483518999142798,2.2033813571255592,19.669226693403971,32.142059805068648,12.472833111664675,14.497054278872076,85.502945721127915]
[null,null,null,null,null,null,null,0.31234393621125289,0.55272126624257245,63,5.6169970999184473,12.763606331212863,1051.9200345896527,1070.8628866203023,6.1792456994367839,18.942852030649647,null,63,1217.2133608069107,2877.0351950210093,4094.2485558279191,189.60630420162397,1406.8196650085347,100,2.0450632491006266,2.9102866967693979,28.770351950210092,40.942485558279188,12.172133608069107,13.477655233122841,86.522344766877154]
[null,null,null,null,null,null,null,0.11870146266642767,0.74086482417687516,64,1.8953827282058409,13.704324120884376,1057.5370316895712,1084.5672107411867,13.325854930731129,27.030179051615505,null,64,1256.2418036307006,2408.8071146836846,3665.0489183143859,233.50100559473049,1489.7428092254311,100,1.6169281702632328,2.4601890310314514,24.088071146836846,36.650489183143861,12.562418036307006,15.673913923178173,84.326086076821824]
[null,null,null,null,null,null,null,0.31354784070593122,0.87357183132775418,65,{"$f":"-$D$6*LN(1-H70)","v":5.6432811607187316},14.367859156638771,1059.432414417777,1098.9350698978255,25.134796323409816,39.502655480048588,null,65,1221.7490835757051,3487.7201433532091,4709.4692269289135,156.36762761972204,1378.1167111954271,100,2.530787207658078,3.417322487036496,34.877201433532093,47.094692269289133,12.217490835757051,11.346472062158163,88.653527937841829]
[null,null,null,null,null,null,null,0.36408638678326533,1.69847024681824E-2,66,6.7903882971462739,10.084923512340913,1065.0756955784957,1109.0199934101665,33.859374319329923,43.944297831670838,null,66,1260.6298703840544,3103.0983267458591,4363.7281971299126,69.389091765690409,1330.0189621497448,100,2.3331233727151073,3.2809518670897018,31.030983267458591,43.637281971299124,12.606298703840544,5.2171505625404766,94.782849437459532]
[null,null,null,null,null,null,null,0.66078791938238401,0.64709953288654476,67,16.216946410053602,13.235497664432724,1071.8660838756421,1122.2554910745991,37.15390953452436,50.389407198957088,null,{"$f":"+R71+1","v":67},1244.543359938888,5157.4283163738255,6401.9716763127135,118.75736599699758,1363.3007259358856,100,3.7830452359169162,4.6959350600490994,51.574283163738258,64.019716763127136,12.445433599388879,8.7110175867817006,91.288982413218307]
[null,null,null,null,null,null,null,0.71474854328159154,0.25140678513025183,68,18.815762751599863,11.257033925651259,1088.0830302856957,1133.5125250002504,34.172460788903464,45.429494714554721,null,68,1262.6425374964147,2975.349901249584,4237.9924387459996,130.50378034936148,1393.1463178457761,100,2.1357052472782407,3.0420296737382277,29.753499012495841,42.379924387459994,12.626425374964146,9.3675573540013826,90.632442645998609]
[null,null,null,null,null,null,null,8.7751656490247187E-2,0.61918565738760045,69,1.3776452924474079,13.095928286938001,1106.8987930372955,1146.6084532871885,26.613731962954976,39.709660249892977,null,69,1243.8357357022064,2583.9581969709548,3827.7939326731625,374.6899260219991,1618.5256617242055,100,1.5964888651924616,2.3649881019467043,25.839581969709549,38.277939326731627,12.438357357022063,23.150076324575799,76.849923675424208]
[null,null,null,null,null,null,null,0.22645656839597017,0.3130631201655254,70,3.8516019163436792,11.565315600827628,1108.2764383297429,1158.1737688880162,38.332014957445693,49.897330558273325,null,70,1246.2778643121333,2894.0530578377843,4140.3309221499185,91.530213438270721,1337.808077750404,100,2.1632797005563682,3.0948616554267687,28.940530578377842,41.403309221499185,12.462778643121332,6.841804512960012,93.15819548703999]
[null,null,null,null,null,null,null,0.51738645245200665,0.65017212062227914,71,10.928085812753595,13.250860603111395,1112.1280402460866,1171.4246294911277,46.045728641929713,59.296589245041105,null,71,1255.9702520618566,3592.4684228268911,4848.4386748887464,204.78245645383731,1460.7527085156939,100,2.4593268948837239,3.3191372137282307,35.924684228268909,48.484386748887466,12.559702520618567,14.018968115549256,85.981031884450744]
[null,null,null,null,null,null,null,0.52310395388023523,0.67463855030369124,72,11.106851167613044,13.373192751518456,1123.0561260588402,1184.7978222426461,48.368503432287511,61.741696183805971,null,72,1257.9752144073843,2747.4283616963598,4005.4035761037439,161.71685250190922,1419.6920669092935,100,1.9352283679922102,2.8213185587657832,27.4742836169636,40.05403576103744,12.579752144073844,11.390980922642683,88.609019077357317]
[null,null,null,null,null,null,null,0.38372050564044291,3.191681639512145E-2,73,7.2608204061124875,10.159584081975607,1134.1629772264532,1194.9574063246218,50.634845016193012,60.794429098168621,null,73,1258.4425929075119,2341.9383467740608,3600.3809396815741,238.38073667005392,1496.8233295775658,100,1.5646057223299719,2.4053479582641697,23.419383467740609,36.00380939681574,12.584425929075119,15.925776406580317,84.074223593419688]
[null,null,null,null,null,null,null,0.4960973450830124,3.7963312193423082E-3,74,10.280582618574664,10.018981656096711,1141.4237976325658,1204.9763879807185,53.533608692056049,63.552590348152762,null,74,1258.8523179446238,1331.811890108178,2590.6642080528013,570.09085013509457,1828.9431680797184,100,0.7281865906782119,1.4164815251054765,13.31811890108178,25.906642080528012,12.588523179446238,31.170506557273512,68.829493442726488]
[null,null,null,null,null,null,null,0.87177768337386641,2.1774505658206378E-2,75,30.80984509497361,10.108872528291032,1151.7043802511405,1215.0852605090095,53.272007729577936,63.380880257868967,null,75,1231.6116105795691,2491.2317419452165,3722.8433525247847,124.40931847436946,1356.0209290539385,100,1.8371631945852678,2.7454173256176202,24.912317419452165,37.228433525247844,12.316116105795691,9.1745868967646906,90.825413103235306]
[null,null,null,null,null,null,null,0.42344657592913348,0.41586291669327191,76,8.2603091082898779,12.07931458346636,1182.514225346114,1227.1645750924758,32.57103516289547,44.650349746361826,null,76,1259.8811264203678,2506.2857931779372,3766.1669195983072,278.27539456118552,1538.1565209815533,100,1.6294088143764365,2.4484939394821668,25.062857931779373,37.661669195983073,12.598811264203677,18.091487489427145,81.908512510572848]
[null,null,null,null,null,null,null,0.13174187808117277,1.5619500585112078E-2,77,2.118993495698879,10.07809750292556,1190.7745344544039,1237.2426725954015,36.390040638071994,46.468138140997553,null,77,1242.1804723889754,2485.9182571240958,3728.0987295130717,264.07319036220679,1506.2536627511822,100,1.6503981491295097,2.4750802747949336,24.859182571240957,37.280987295130714,12.421804723889755,17.531787433457612,82.468212566542391]
[null,null,null,null,null,null,null,0.68836808987562947,0.62841917773348821,78,17.488988443465761,13.142095888667441,1192.8935279501029,1250.3847684840689,44.349144645298551,57.491240533965993,null,78,1250.3003773479625,2160.0129526590736,3410.3133300070358,400.27186779333852,1650.572245141301,100,1.3086449011955612,2.066139994808339,21.600129526590734,34.103133300070361,12.503003773479625,24.25049063872223,75.749509361277774]
[null,null,null,null,null,null,null,5.1383397300953093E-2,0.50820159969465584,79,0.79125845060425481,12.54100799847328,1210.3825163935687,1262.9257764825422,40.002252090500235,52.543260088973511,null,79,1228.642042391434,1233.4067264685427,2462.0487688599769,440.15813034106145,1668.8001727324954,100,0.73909791395153146,1.4753406723518103,12.334067264685427,24.62048768859977,12.28642042391434,26.37572415997213,73.624275840027863]
[null,null,null,null,null,null,null,2.6015628973791394E-2,0.16745365455868044,80,0.39540032464000496,10.837268272793402,1211.1737748441731,1273.7630447553356,51.752001638369144,62.589269911162546,null,80,1251.7975732150742,2785.0648094250546,4036.8623826401281,271.28332482952601,1523.0808980446002,100,1.8285731329180519,2.6504582834850292,27.850648094250545,40.368623826401283,12.517975732150742,17.811484943302208,82.188515056697796]
[null,null,null,null,null,null,null,0.2787776328701761,0.67083125293225065,81,4.9021166154812583,13.354156264661253,1211.569175168813,1287.1172010199969,62.193869586522609,75.548025851183866,null,81,1250.9239521504014,1853.9272566097029,3104.851208760103,357.64670307546453,1608.5706552258659,100,1.1525308201953899,1.9301926208047966,18.539272566097029,31.048512087601029,12.509239521504014,22.233819939059245,77.766180060940755]
[null,null,null,null,null,null,null,0.76622444738312478,0.72137257782807429,82,21.800907011698165,13.606862889140372,1216.4712917842942,1300.7240639091372,70.645909235702604,84.252772124842977,null,82,1284.319670222287,2162.3205508164101,3446.6402210386977,189.87375265873607,1474.193422881023,100,1.4667821177702565,2.3379837187869912,21.623205508164101,34.466402210386974,12.843196702222869,12.879839898326564,87.120160101673434]
[null,null,null,null,null,null,null,0.22677510388629785,0.38329792486661163,83,3.8577800004650555,11.916489624333058,1238.2721987959924,1312.6405535334702,62.45186511314477,74.36835473747783,null,83,1240.432105004337,1717.1210073377626,2957.5531123420988,337.52999618274021,1577.9621011870772,100,1.08818900406163,1.8742865307837089,17.171210073377626,29.575531123420987,12.40432105004337,21.390247327792057,78.609752672207946]
[null,null,null,null,null,null,null,0.23802470948069065,0.81327072771531295,84,4.0776172644191373,14.066353638576565,1242.1299787964574,1326.7069071720468,70.51057473701286,84.576928375589432,null,84,1262.15006133462,2195.9757191414142,3458.1257804760326,322.69191069284193,1584.8419720274619,100,1.385611788367858,2.182000377016839,21.959757191414141,34.581257804760327,12.6215006133462,20.361141135101786,79.638858864898211]
[null,null,null,null,null,null,null,0.53547633259645411,6.9940706014539389E-2,85,11.501141543950228,10.349703530072697,1246.2075960608765,1337.0566107021195,80.4993111111703,90.849014641243002,null,85,1248.6700471009767,2109.0685620563877,3357.7386091573644,244.85518916935621,1493.5252362703329,100,1.4121412285762269,2.2481967680321158,21.090685620563878,33.577386091573644,12.486700471009767,16.394446054411137,83.605553945588866]
[null,null,null,null,null,null,null,0.78894401549711202,0.88874001408932246,86,23.334477769531748,14.443700070446612,1257.7087376048269,1351.5003107725661,79.347873097292606,93.791573167739216,null,86,1249.3810681303853,779.7419811054001,2029.1230492357863,500.52666652928406,1749.9077346596694,100,0.4455903392283983,1.1595600208204235,7.7974198110540014,20.291230492357862,12.493810681303852,28.603031840797534,71.396968159202473]
[null,null,null,null,null,null,null,0.69927973085704465,0.9182269864681859,87,18.023621770971282,14.591134932340928,1281.0432153743586,1366.0914457049071,70.457095398207514,85.048230330548449,null,87,1268.4681631589483,4567.1688837712418,5835.6370469301874,107.98650288710792,1376.4546660460562,100,3.318067057661036,4.2396144173010688,45.671688837712416,58.356370469301872,12.684681631589482,7.8452640359965686,92.154735964003436]
[null,null,null,null,null,null,null,0.59858437412857901,0.90792566006663145,88,13.691368724228102,14.539628300333156,1299.0668371453298,1380.6310740052402,67.024608559577189,81.564236859910352,null,88,1230.6687035141224,1367.6147826023323,2598.2834861164552,431.37693416435445,1662.0456376784769,100,0.82285031866669944,1.563304537019635,13.676147826023323,25.982834861164552,12.306687035141223,25.954578164706476,74.045421835293524]
[null,null,null,null,null,null,null,0.37731216019502956,9.1782864212219484E-2,89,7.1056491820521313,10.458914321061098,1312.758205869558,1391.0899883263012,67.872868135682111,78.331782456743213,null,89,1254.3863416876773,2917.2901526998944,4171.6764943875742,244.38803401870609,1498.7743757063834,100,1.9464505131567613,2.7833919247661494,29.172901526998945,41.716764943875745,12.543863416876773,16.305858839061365,83.694141160938642]
[null,null,null,null,null,null,null,0.52677822259384322,0.54772276780878104,90,11.2228668955273,12.738613839043905,1319.86385505161,1403.828602165345,71.226133274691122,83.964747113735029,null,90,1253.2563987810734,2988.8547084423712,4242.1111072234453,179.23831772469634,1432.4947165057697,100,2.0864682249809423,2.9613450286023162,29.888547084423713,42.421111072234453,12.532563987810734,12.512319637862651,87.48768036213734]
[null,null,null,null,null,null,null,0.86167374273959541,0.99889578499175358,91,29.672103015934475,14.994478924958768,1331.0867219471372,1418.8230810903037,72.74188021820774,87.73635914316651,null,91,1212.8574182105742,3871.5078701006933,5084.3652883112682,154.77491529620465,1367.6323335067789,100,2.8308104270785024,3.7176404533185647,38.715078701006931,50.843652883112682,12.128574182105742,11.316997375993779,88.683002624006221]
[null,null,null,null,null,null,null,0.24382112032839909,6.5544284825594379E-2,92,4.1921597620334676,10.327721424127972,1360.7588249630717,1429.1508025144317,58.064256127232042,68.391977551360014,null,92,1255.0432482188035,1598.4154622498697,2853.4587104686734,459.99408382316187,1715.0373320419653,100,0.93200038995463574,1.6637881037092503,15.984154622498698,28.534587104686736,12.550432482188034,26.821228624538552,73.178771375461451]
[null,null,null,null,null,null,null,0.71744157258352803,0.24518945809701309,93,18.958048906010024,11.225947290485065,1364.9509847251052,1440.3767498049167,64.19981778932646,75.425765079811526,null,93,1250.4352079729274,4961.7832743115441,6212.2184822844711,137.11260990938945,1387.5478178823168,100,3.5759367788017893,4.4771202853142702,49.617832743115443,62.122184822844709,12.504352079729275,9.881649348751921,90.118350651248079]
[null,null,null,null,null,null,null,0.68592586916873621,0.53851693843742654,94,17.371893532316751,12.692584692187133,1383.9090336311151,1453.0693344971039,56.467716173801669,69.160300865988802,null,94,1240.5831720828323,1191.2333638192331,2431.8165359020659,345.8059389022203,1586.3891109850526,100,0.75090868663334964,1.532925635370791,11.912333638192331,24.318165359020657,12.405831720828324,21.798305126255912,78.201694873744088]
[null,null,null,null,null,null,null,0.11286735444517626,0.85687103568488965,95,1.7964114573436567,14.284355178424448,1401.2809271634319,1467.3536896755284,51.788407333672012,66.07276251209646,null,95,1235.0093655399887,1855.1021631058218,3090.1115286458098,304.82280641545253,1539.8321719554413,100,1.2047430862221935,2.006784625574916,18.551021631058219,30.901115286458097,12.350093655399887,19.795846064727716,80.204153935272288]
[null,null,null,null,null,null,null,0.46586606467916358,0.83530892557071534,96,9.4066298439488865,14.176544627853577,1403.0773386207757,1481.530234303382,64.276351054752794,78.452895682606368,null,96,1261.6909487637847,2744.3667737169862,4006.0577224807703,333.0539528480424,1594.7449016118271,100,1.7208813591084211,2.5120367015638685,27.443667737169861,40.060577224807702,12.616909487637848,20.884465754455206,79.115534245544794]
[null,null,null,null,null,null,null,0.53843628093370122,0.31262687867165539,97,11.597027476307597,11.563134393358277,1412.4839684647245,1493.0933686967403,69.046265838657504,80.609400232015787,null,97,1235.9524606257012,2150.9970724468326,3386.9495330725331,288.95019496375949,1524.9026555894607,100,1.4105799242741506,2.2210922911425364,21.509970724468324,33.869495330725329,12.359524606257011,18.948763313161386,81.051236686838607]
[null,null,null,null,null,null,null,0.31200286265671784,0.78693462453007268,98,5.6095590284355357,13.934673122650363,1424.0809959410321,1507.0280418193906,69.012372755708128,82.947045878358495,null,98,1256.0873020945667,2762.2624082318312,4018.3497103263962,170.89595311859398,1426.9832552131606,100,1.9357356844521687,2.8159753771785789,27.62262408231831,40.18349710326396,12.560873020945667,11.976030727358872,88.023969272641139]
[null,null,null,null,null,null,null,0.56415484277762373,0.25409260667313605,99,12.457023640455578,11.270463033365679,1429.6905549694677,1518.2985048527564,77.337486849923039,88.607949883288711,null,99,1257.0480690365293,1800.3670863134996,3057.4151553500287,277.14092585075196,1534.1889948872813,100,1.1734975888324468,1.9928543129555305,18.003670863134996,30.574151553500286,12.570480690365294,18.064327587691622,81.935672412308378]
[null,null,null,null,null,null,null,0.17213543025274691,0.64194850702213047,100,2.8335855162294514,13.209742535110653,1442.1475786099234,1531.5082473878672,76.150926242833179,89.360668777943829,null,100,1251.9392177371299,1083.1785253646231,2335.1177431017522,575.33625836603096,1827.2754761031608,100,0.59278337586766316,1.2779232106160663,10.831785253646231,23.351177431017522,12.519392177371298,31.486016525159656,68.513983474840344]

{"sheet":"Sheet3","index":2,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5.4 - Simulação"]
[]
[null,"Chegada Exponencial de média",null,null,15]
[null,"Serviço Uniforme de min - máx","min-max",null,10,15]
[]
[null,"Nº Clientes",10]
[null,null,null,null,null,null,"Próx.",null,"Próx.","Próxima","Próxima","Próximo","Tempo",null,"NPA ","NPA ","Nº","Intervalo","Tempo ","Tempo","Tempo","Tempo","Tempo "]
[null,"Cliente Ch.","Cliente Nº","T. Simul.","Nº Clientes","NPA Ch","Int. CH","NPA Par","T. Serv.","Chegada","Partida","Acontec.","Espera",null,"Chegadas","Seviço","Clientes","Chegadas","Serviço","Chegada","Partida","Fila","Sistema"]
[null,1,{"$f":"SUM($B$9:B9)","v":1},0,1,{"$f":"RAND()","v":0.84639532186503386},{"$f":"-$E$3*LN(F9)","v":2.5015311748568068},{"$f":"RAND()","v":0.38010039694829045},{"$f":"$E$4+H9*($F$4-$E$4)","v":11.900501984741453},{"$f":"+D9+G9","v":2.5015311748568068},{"$f":"+D9+I9","v":11.900501984741453},{"$f":"IF(J9<K9,\"chegada\",\"partida\")","v":"chegada"},{"$f":"IF(E9<2,0,(E9-1)*(D10-D9))","v":0},null,{"$f":"RAND()","v":1.5222796396505478E-2},{"$f":"RAND()","v":0.90415936037352951},1,{"$f":"-$E$3*LN(O9)","v":62.774418175846961},{"$f":"$E$4+P9*($F$4-$E$4)","v":14.520796801867647},0,{"$f":"+T9+S9","v":14.520796801867647},{"$f":"+U9-T9-S9","v":0},{"$f":"+U9-T9","v":14.520796801867647}]
[null,{"$f":"IF(SUM(E9:L9)=0,0,IF(L9=\"partida\",0,1))","v":1},{"$f":"SUM($B$9:B10)","v":2},{"$f":"IF(L9=\"partida\",K9,J9)","v":2.5015311748568068},{"$f":"IF(L9=\"partida\",E9-1,E9+1)","v":2},{"$f":"IF(L9=\"partida\", 0,RAND())","v":0.38089398033291832},{"$f":"IF(F10=0,0,-$E$3*LN(F10))","v":14.478513141323576},{"$f":"IF(L9=\"partida\",IF(E10=0,0,RAND()),IF(E10>1,0,RAND()))","v":0},{"$f":"IF(H10=0,0,$E$4+H10*($F$4-$E$4))","v":0},{"$f":"IF(C10=$C$6,0,+J9+G10)","v":16.980044316180383},{"$f":"IF(D10<K9,K9,IF(I10=0,0,D10+I10))","v":11.900501984741453},{"$f":"IF(C10<$C$6,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\"))),IF(E10=0,0,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\")))))","v":"partida"},9.3989708098846467,null,{"$f":"RAND()","v":0.6800441556646547},{"$f":"RAND()","v":0.42955507916397306},{"$f":"+Q9+1","v":2},{"$f":"-$E$3*LN(O10)","v":5.7839632217879213},{"$f":"$E$4+P10*($F$4-$E$4)","v":12.147775395819865},{"$f":"+T9+R9","v":62.774418175846961},{"$f":"MAX(T10,U9)+S10","v":74.922193571666824},0,12.147775395819863]
[null,0,{"$f":"SUM($B$9:B11)","v":2},11.900501984741453,{"$f":"IF(L10=\"partida\",E10-1,E10+1)","v":1},{"$f":"IF(L10=\"partida\", 0,RAND())","v":0},0,0.90882284503234234,14.544114225161712,16.980044316180383,26.444616209903167,"chegada",0,null,{"$f":"RAND()","v":0.30524126377008753},0.90567628826021651,3,17.799791794780408,14.528381441301082,{"$f":"+T10+R10","v":68.558381397634889},{"$f":"MAX(T11,U10)+S11","v":89.450575012967903},6.3638121740319313,20.892193615333014]
[null,1,{"$f":"SUM($B$9:B12)","v":3},16.980044316180383,{"$f":"IF(L11=\"partida\",E11-1,E11+1)","v":2},{"$f":"IF(L11=\"partida\", 0,RAND())","v":0.52527053500840282},9.6576276650477499,0,0,26.637671981228131,26.444616209903167,"partida",9.4645718937227841,null,0.60535079997470853,0.24076384685341934,4,7.5292073148228607,11.203819234267097,86.358173192415293,100.654394247235,3.0924018205526131,14.296221054819711]
[null,0,{"$f":"SUM($B$9:B13)","v":3},26.444616209903167,{"$f":"IF(L12=\"partida\",E12-1,E12+1)","v":1},{"$f":"IF(L12=\"partida\", 0,RAND())","v":0},0,0.38062927491218546,11.903146374560928,26.637671981228131,38.347762584464093,"chegada",0,null,2.7960327951484842E-2,1.1866382289594135E-2,5,53.654529485641937,10.05933191144797,93.887380507238149,110.71372615868297,6.7670137399968553,16.826345651444825]
[null,1,{"$f":"SUM($B$9:B14)","v":4},26.637671981228131,{"$f":"IF(L13=\"partida\",E13-1,E13+1)","v":2},{"$f":"IF(L13=\"partida\", 0,RAND())","v":0.16436155202195657},27.085300382867068,0,0,53.722972364095199,38.347762584464093,"partida",11.710090603235962,null,0.25512270205924825,0.44164910745503327,6,20.49015997514698,12.208245537275166,147.54190999288008,159.75015553015524,0,12.208245537275161]
[null,0,{"$f":"SUM($B$9:B15)","v":4},38.347762584464093,{"$f":"IF(L14=\"partida\",E14-1,E14+B15)","v":1},{"$f":"IF(C15=$C$6,0, RAND())","v":0.10186888840988806},34.261030504338443,0.7461950425546926,13.730975212773462,87.984002868433635,52.078737797237551,"partida",0,null,0.8271091443458235,0.8842282195077773,7,2.8472792464826004,14.421141097538886,168.03206996802706,182.45321106556594,0,14.421141097538879]
[null,0,{"$f":"SUM($B$9:B16)","v":4},52.078737797237551,0,0.25440217949995203,20.532583205041139,0,0,108.51658607347477,0,"chegada",0,null,0.94605754855616131,0.35447047018990485,8,0.83177817317496616,11.772352350949525,170.87934921450966,194.22556341651546,11.573861851056272,23.346214202005797]
[null,1,{"$f":"SUM($B$9:B17)","v":5},108.51658607347477,1,0.3673117110990457,15.023166635649543,0.54095947244935882,12.704797362246794,123.53975270912431,121.22138343572156,"partida",0,null,9.2069296515933097E-3,0.63410415302065892,9,70.316982831869225,13.170520765103294,171.71112738768463,207.39608418161876,22.51443602883084,35.684956793934134]
[null,0,{"$f":"SUM($B$9:B18)","v":5},121.22138343572156,0,0.43984002936894806,12.320162816899707,{"$f":"IF(L17=0,0,IF(L17=\"partida\",IF(E18=0,0,RAND()),IF(E18>1,0,RAND())))","v":0},0,135.85991552602403,0,"chegada",0,null,0.89210088076739569,0.93490500112457176,10,1.712640866492638,14.674525005622858,242.02811021955387,256.70263522517672,0,14.674525005622854]
[null,1,{"$f":"SUM($B$9:B19)","v":6},135.85991552602403,1,0.80441360664311301,3.2646255893519229,0.75299045816746513,13.764952290837325,139.12454111537596,149.62486781686135,"chegada",0]
[null,1,{"$f":"SUM($B$9:B20)","v":7},139.12454111537596,2,0.24213080250235786,21.274157889573399,0,0,160.39869900494935,149.62486781686135,"partida",10.500326701485392]
[null,0,{"$f":"SUM($B$9:B21)","v":7},149.62486781686135,1,0.7823848645762238,3.6811275797315015,0.42808338184174299,12.140416909208716,164.07982658468086,161.76528472607006,"partida",0]
[null,0,{"$f":"SUM($B$9:B22)","v":7},161.76528472607006,0,0.62202512171023716,7.1216219768533158,0,0,171.20144856153416,0,"chegada",0]
[null,1,{"$f":"SUM($B$9:B23)","v":8},171.20144856153416,1,0.58691680929084911,7.9930828652836237,0.50555461511916788,12.527773075595839,179.19453142681778,183.72922163713,"chegada",0]
[null,1,{"$f":"SUM($B$9:B24)","v":9},179.19453142681778,2,0.28412194676946212,18.875276144236992,0,0,198.06980757105475,183.72922163713,"partida",4.5346902103122204]
[null,0,{"$f":"SUM($B$9:B25)","v":9},183.72922163713,1,0.12554801441874341,31.12600512851062,0.47686792609370232,12.384339630468512,229.19581269956538,196.1135612675985,"partida",0]
[null,0,{"$f":"SUM($B$9:B26)","v":9},196.1135612675985,0,0.63270567946365863,6.8662488947825828,0,0,236.06206159434797,0,"chegada",0]
[null,1,{"$f":"SUM($B$9:B27)","v":10},236.06206159434797,1,0,0,0.16539249688508384,10.826962484425419,0,246.88902407877339,"partida",0]
[null,0,{"$f":"SUM($B$9:B28)","v":10},246.88902407877339,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B29)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B30)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B31)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B32)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B33)","v":10},0,0,0,{"$f":"-15*LN(1-F33)","v":0},0,0,0,0,0,0]
[]
[]
[null,null,null,null,"Medidas de Performance",null,null,null,null,null,null,null,null,null,null,null,null,"Medidas de Performance"]
[]
[null,null,"Tempo Total de Simulação",null,null,null,{"$f":"MAX(D9:D33)","v":246.88902407877339},"minutos",null,null,null,null,null,null,null,"Tempo Total de Simulação",null,null,null,null,{"$f":"MAX(U9:U33)","v":256.70263522517672},"minutos"]
[null,null,"Tempo de Actividade (Serviço)",null,null,null,{"$f":"SUM(I9:I29)","v":126.42797955002017},"\"",null,null,null,null,null,null,null,"Tempo Total de Actividade (Serviço)",null,null,null,null,{"$f":"SUM(S9:S33)","v":128.70688954119339},"\""]
[null,null,"Tempo Total na Fila",null,null,null,{"$f":"SUM(M9:M29)","v":45.608650218641003},"\"",null,null,null,null,null,null,null,"Tempo Total na Fila",null,null,null,null,{"$f":"SUM(V9:V9:V33)","v":50.311525614468508},"\""]
[null,null,"Tempo no Sistema",null,null,null,{"$f":"+G40+G39","v":172.03662976866116},"\"",null,null,null,null,null,null,null,"Tempo Total no Sistema",null,null,null,null,{"$f":"SUM(W9:W10:W33)","v":179.0184151556619},"\""]
[null,null,"Tempo de Inactividade",null,null,null,{"$f":"+G38-G39","v":120.46104452875322},"\"",null,null,null,null,null,null,null,"Tempo Total de Inactividade",null,null,null,null,{"$f":"+U38-U39","v":127.99574568398333},"\""]
[]
[null,null,"Comprimento médio da Fila",null,null,null,{"$f":"+G40/D18","v":0.37624261434720624},"clientes",null,null,null,null,null,null,null,"Compriento médio fila",null,null,null,null,{"$f":"+U40/U38","v":0.19599146526227046},"clientes"]
[null,null,"Nº médio clientes no Sistema",null,null,null,{"$f":"+G41/D18","v":1.4191937502502165},"\"",null,null,null,null,null,null,null,"Nº médio Clientes no Sistema",null,null,null,null,{"$f":"+U41/U38","v":0.69737661632740511},"\""]
[null,null,"Tempo médio na Fila",null,null,null,{"$f":"+G40/MAX(C9:C33)","v":4.5608650218641005},"\"",null,null,null,null,null,null,null,"Tempo médio na fila",null,null,null,null,{"$f":"+U40/MAX(Q9:Q33)","v":5.0311525614468504},"minutos"]
[null,null,"Tempo médio no Sistema",null,null,null,{"$f":"+G41/MAX(C9:C33)","v":17.203662976866116},"\"",null,null,null,null,null,null,null,"Tempo médio no Sistema",null,null,null,null,{"$f":"+U41/MAX(Q9:Q33)","v":17.90184151556619},"\""]
[]
[null,null,"% Utilização média do Serviço",null,null,null,{"$f":"+G39/G38*100","v":51.208424522623396}," %",null,null,null,null,null,null,null,"%Utilização do Sistema",null,null,null,null,{"$f":"+U39/U38*100","v":50.138515106513474},"%"]
[null,null,"% Inactividade do Sistema",null,null,null,{"$f":"+G42/G38*100","v":48.791575477376604},"%",null,null,null,null,null,null,null,"% Inactividade do Sistema",null,null,null,null,{"$f":"+U42/U38*100","v":49.861484893486534},"%"]